James Keuning
James Keuning
Reactions
-
Re: How do I populate the highest parent level data into another cell?
I do it like this: =IF(COUNT(ANCESTORS([Primary Column]@row)) = 0, [Primary Column]@row, INDEX(ANCESTORS([Primary Column]@row), 1))6 · -
Re: Trying to identify cells in ALL CAPS vs Title Caps
Put your urls in a field called IN Create a field called OUT, and put this formula: =UPPER(In@row) Then create two fields called whatever, like, COUNT CAPS IN and COUNT CAPS OUT COUNT CAPS IN: =FIND(…1 · -
Re: Displaying first entry and hiding duplicate names on project plan sheet
Also, if you really want to be fancy, you can use this column formula in a checkbox column: =[Row ID]@row - (MAX(COLLECT([Row ID]:[Row ID], [Row ID]:[Row ID], <[Row ID]@row))) = 1 to make sure tha…1 · -
Re: Sort in sheets
I create my own sort field. Basically concatenate the fields I want to sort on. But yeah, I am totally in support of this. And soon some people will tell us to put in an enhancement request, or feedb…1 · -
Re: How do i collect data on single sheet from multiple participants outside of Organization
Yes, I left out a very important NOT! I am not sure what @Vinita Soman means by "contact list option." I recommend creating a Smartsheet account (an "alt" account) with the same p…1 ·
